3 tier and 4 tire Architecture in Oracle DBA

Ratings:
(4)
Views: 711
Banner-Img
Share this blog:

 

3 tier Architecture

                                                                     3-tier architecture  

Inclined to build a profession as Oracle DBA Training? Then here is the blog post on, explore Oracle DBA Training

4 tier Architecture

We can add ‘n’ no.of architectures  

Library cache performs

  • Syntactical checking & whether SQL statement is valid or not like expressions messing from ok
  • Semantically checking whether the user is valid or not checks the privileges.
  • Data dictionary cache checks in base tables whether the table is available or not if available then the optimizer the oracle brain] checks whether the table has an index or not then the DDC makes an execution plan. 

 

4-tier Architecture

    updating db file       Redo log files

IF there is any update Then DBWR does 3 things i) updating db files ii) updating redo log files iii) updating index files Architecture files    

Inclined to build a profession as Client-server computing? Then here is the blog post on, explore Client-server computing

You liked the article?

Like: 0

Vote for difficulty

Current difficulty (Avg): Medium

EasyMediumHardDifficultExpert
IMPROVE ARTICLEReport Issue

About Author

Authorlogo
Name
TekSlate
Author Bio

TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills in the market.